<?php
	
	$keywords = !empty(@$_GET['keywords']) ? @$_GET['keywords'] : '';
	if(!empty($keywords)){
		$where = " where xx=2 id like '%$keywords%' ";
		$link = "&keywords=".$keywords;
	}else{
		$where = " where xx=2";
		$link = "";
	}
	
	//开始分页大小
	$page_size = 5;
	
	//获取当前页码
	$page_num = empty($_GET['page'])?1:$_GET['page'];
	
	//计算记录总数
	$sql = "select count(*) as c from bbs_reply ".$where;
	$row = mysql_func($sql);
	$count= $row[0]['c'];
	
	//计算记录总页数
	$page_count = ceil($count/$page_size);
	
	//防止越界
	if($page_num<=0){
		$page_num=1;
	}
	if($page_num>=$page_count){
		$page_num=$page_count;
	}
	
	//准备SQL语句
	$limit = " limit ".(($page_num-1)*$page_size).",".$page_size;;
	
	$sql = "select * from bbs_reply".$where.$limit;


	$row = mysql_func($sql);
	
	/*echo "<pre>";
	var_dump($row);
	echo "</pre>";
	exit;*/
?>
<div class="container"><div class="row">
		<form>
		搜索ID：<input type='text' name='keywords'  class='input-medium search-query' />&nbsp;&nbsp;&nbsp;
		<input type='submit' value='搜索' class='btn' />
		</form></div></div>
        
	<form action="del.php" method="post">
		<input class="form-control" type="hidden" name="zd" value="id" />
		<input class="form-control" type="hidden" name="table" value="reply" />
	<table border="2px"  class="table table-bordered">
	
		<tr >
			<th>多选</th>
			<th>ID</th>
			<th>回帖内容</th>
			<th>回帖的主题</th>
			<th>回帖人</th>
			<th>回帖时间</th>
			<th>回帖IP</th>
			<th>管理</th>
		<tr>

<?php foreach($row as $reply){
?>
		<tr align="center">
			<td><input class="form-control" type="checkbox" name="id[]" value="<?php echo $reply['id'] ?>" /></td>
			<td><?php echo $reply['id'] ?></td>
			<td><?php echo $reply['content'] ?></td>
			<td><?php
				$sql = "select title from bbs_post where id=".$reply['pid'];
				$row1 = mysql_func($sql);
				$post = $row1[0];
			echo $post['title'] ?></td>
			<td><?php
			$sql = "select username from bbs_user where '".$reply['pid']."'";

				$row1 = mysql_func($sql);
				$user = $row1[0];
			echo $user['username'] ?></td>
			<td><?php echo date('Y-m-d H:i:s',$reply['ptime']); ?></td>
			<td><?php echo long2ip($reply['pip']) ?></td>
			<td><a href="./index.php?m=reply&a=mod&id=<?php echo $reply['id'] ?>"class="btn btn-outline-info" >编辑</a>
				<a href="./index.php?m=reply&a=del&id=<?php echo $reply['id'] ?>&zd=id&table=reply&cz=1">恢复</a>
				<a href="./index.php?m=reply&a=del&id=<?php echo $reply['id'] ?>&zd=id&table=reply"class="btn btn-outline-danger" >删除</a>
			</td>
		</tr>
<?php
	}
?>	
		
		
	</table>
		<input type='submit'  value='批量删除' class="btn btn-outline-info navbar-btn" />
</form></div></div>
<?php
	echo "
	<ul class='pager'>
		<li><a href='?m=reply&a=list_pb&page=1".$link."'>首页</a></li>
		<li><a href='?m=reply&a=list_pb&page=".($page_num-1).$link."'>上一页</a></li>
		<li><li><a href='?m=reply&a=list_pb&page=".($page_num+1).$link."'>下一页</a></li>
		<li><a href='?m=reply&a=list_pb&page=".$page_count.$link."'>尾页</a></li>
		<li>总共".$page_count."页</li>
		<li>本页".(($page_num==$page_count&&$count%$page_size!=0)?($count%$page_size):$page_size)."条</li>
		<li>总共".$count."条</li>
	</ul>
	";
?>